Overview
Brought to you by YData
Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 9994 |
| Missing cells | 543 |
| Missing cells (%) | 0.3% |
| Duplicate rows | 1 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 6.8 MiB |
| Average record size in memory | 718.1 B |
Variable types
| Numeric | 7 |
|---|---|
| Categorical | 10 |
| Text | 3 |
| DateTime | 1 |
Country has constant value "United States" | Constant |
| Dataset has 1 (< 0.1%) duplicate rows | Duplicates |
Category is highly overall correlated with Sub-Category | High correlation |
Days to Ship Actual is highly overall correlated with Days to Ship Scheduled and 2 other fields | High correlation |
Days to Ship Scheduled is highly overall correlated with Days to Ship Actual and 2 other fields | High correlation |
Discount is highly overall correlated with Profit Ratio and 1 other fields | High correlation |
Profit Ratio is highly overall correlated with Discount | High correlation |
Profit per Order is highly overall correlated with Discount and 1 other fields | High correlation |
Region is highly overall correlated with State | High correlation |
Sales per Customer is highly overall correlated with Profit per Order | High correlation |
Ship Mode is highly overall correlated with Days to Ship Actual and 1 other fields | High correlation |
Ship Status is highly overall correlated with Days to Ship Actual and 1 other fields | High correlation |
State is highly overall correlated with Region | High correlation |
Sub-Category is highly overall correlated with Category | High correlation |
Ship Mode has 543 (5.4%) missing values | Missing |
Days to Ship Actual has 519 (5.2%) zeros | Zeros |
Discount has 4798 (48.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-07-02 21:55:14.329661 |
|---|---|
| Analysis finished | 2025-07-02 21:55:24.497867 |
| Duration | 10.17 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
Days to Ship Actual
Real number (ℝ)
High correlation  Zeros 
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9581749 |
| Minimum | 0 |
|---|---|
| Maximum | 7 |
| Zeros | 519 |
| Zeros (%) | 5.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.7475667 |
|---|---|
| Coefficient of variation (CV) | 0.44150822 |
| Kurtosis | -0.28755198 |
| Mean | 3.9581749 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.42132235 |
| Sum | 39558 |
| Variance | 3.0539895 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 2774 | |
| 5 | 2169 | |
| 2 | 1334 | |
| 6 | 1203 | |
| 3 | 1005 | 10.1% |
| 7 | 621 | 6.2% |
| 0 | 519 | 5.2% |
| 1 | 369 | 3.7% |
| Value | Count | Frequency (%) |
| 0 | 519 | 5.2% |
| 1 | 369 | 3.7% |
| 2 | 1334 | |
| 3 | 1005 | 10.1% |
| 4 | 2774 | |
| 5 | 2169 | |
| 6 | 1203 | |
| 7 | 621 | 6.2% |
| Value | Count | Frequency (%) |
| 7 | 621 | 6.2% |
| 6 | 1203 | |
| 5 | 2169 | |
| 4 | 2774 | |
| 3 | 1005 | 10.1% |
| 2 | 1334 | |
| 1 | 369 | 3.7% |
| 0 | 519 | 5.2% |
Ship Status
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 568.8 KiB |
| 2 | |
|---|---|
| -1 | |
| 1 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.2640584 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | -1 |
| 4th row | -1 |
| 5th row | -1 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 4909 | |
| -1 | 2639 | |
| 1 | 2446 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 5085 | |
| 2 | 4909 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 5085 | |
| 2 | 4909 | |
| - | 2639 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 9994 | |
| Dash Punctuation | 2639 | 20.9% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 5085 | |
| 2 | 4909 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2639 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 12633 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 5085 | |
| 2 | 4909 | |
| - | 2639 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12633 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 5085 | |
| 2 | 4909 | |
| - | 2639 |
Days to Ship Scheduled
Categorical
High correlation 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 566.2 KiB |
| 6 | |
|---|---|
| 3 | |
| 1 | |
| 0 | 543 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 3 |
| 3rd row | 3 |
| 4th row | 6 |
| 5th row | 6 |
Common Values
| Value | Count | Frequency (%) |
| 6 | 5968 | |
| 3 | 1945 | 19.5% |
| 1 | 1538 | 15.4% |
| 0 | 543 | 5.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 6 | 5968 | |
| 3 | 1945 | 19.5% |
| 1 | 1538 | 15.4% |
| 0 | 543 | 5.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 5968 | |
| 3 | 1945 | 19.5% |
| 1 | 1538 | 15.4% |
| 0 | 543 | 5.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 9994 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 5968 | |
| 3 | 1945 | 19.5% |
| 1 | 1538 | 15.4% |
| 0 | 543 | 5.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 9994 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 5968 | |
| 3 | 1945 | 19.5% |
| 1 | 1538 | 15.4% |
| 0 | 543 | 5.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9994 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 6 | 5968 | |
| 3 | 1945 | 19.5% |
| 1 | 1538 | 15.4% |
| 0 | 543 | 5.4% |
Sales per Customer
Real number (ℝ)
High correlation 
| Distinct | 5456 |
|---|---|
| Distinct (%) | 54.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 229.85799 |
| Minimum | 0.44 |
|---|---|
| Maximum | 22638.48 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0.44 |
|---|---|
| 5-th percentile | 4.98 |
| Q1 | 17.28 |
| median | 54.49 |
| Q3 | 209.94 |
| 95-th percentile | 956.982 |
| Maximum | 22638.48 |
| Range | 22638.04 |
| Interquartile range (IQR) | 192.66 |
Descriptive statistics
| Standard deviation | 623.24512 |
|---|---|
| Coefficient of variation (CV) | 2.7114355 |
| Kurtosis | 305.31173 |
| Mean | 229.85799 |
| Median Absolute Deviation (MAD) | 45.405 |
| Skewness | 12.972752 |
| Sum | 2297200.8 |
| Variance | 388434.48 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12.96 | 57 | 0.6% |
| 19.44 | 39 | 0.4% |
| 15.55 | 39 | 0.4% |
| 25.92 | 36 | 0.4% |
| 10.37 | 36 | 0.4% |
| 32.4 | 28 | 0.3% |
| 17.94 | 21 | 0.2% |
| 6.48 | 21 | 0.2% |
| 20.74 | 19 | 0.2% |
| 14.94 | 17 | 0.2% |
| Other values (5446) | 9681 |
| Value | Count | Frequency (%) |
| 0.44 | 1 | < 0.1% |
| 0.56 | 1 | < 0.1% |
| 0.84 | 1 | < 0.1% |
| 0.85 | 1 | < 0.1% |
| 0.88 | 1 | < 0.1% |
| 0.9 | 1 | < 0.1% |
| 0.98 | 1 | < 0.1% |
| 0.99 | 1 | < 0.1% |
| 1.04 | 1 | < 0.1% |
| 1.08 | 3 |
| Value | Count | Frequency (%) |
| 22638.48 | 1 | |
| 17499.95 | 1 | |
| 13999.96 | 1 | |
| 11199.97 | 1 | |
| 10499.97 | 1 | |
| 9892.74 | 1 | |
| 9449.95 | 1 | |
| 9099.93 | 1 | |
| 8749.95 | 1 | |
| 8399.98 | 1 |
Profit Ratio
Real number (ℝ)
High correlation 
| Distinct | 288 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.037092 |
| Minimum | -275 |
|---|---|
| Maximum | 50 |
| Zeros | 65 |
| Zeros (%) | 0.7% |
| Negative | 1871 |
| Negative (%) | 18.7% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | -275 |
|---|---|
| 5-th percentile | -76.7 |
| Q1 | 7.5 |
| median | 27 |
| Q3 | 36.3 |
| 95-th percentile | 48 |
| Maximum | 50 |
| Range | 325 |
| Interquartile range (IQR) | 28.8 |
Descriptive statistics
| Standard deviation | 46.677878 |
|---|---|
| Coefficient of variation (CV) | 3.8778367 |
| Kurtosis | 10.172067 |
| Mean | 12.037092 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | -2.8947013 |
| Sum | 120298.7 |
| Variance | 2178.8243 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 48 | 509 | 5.1% |
| 35 | 443 | 4.4% |
| 47 | 353 | 3.5% |
| 26 | 325 | 3.3% |
| 49 | 315 | 3.2% |
| 33.8 | 286 | 2.9% |
| 29 | 278 | 2.8% |
| 46 | 267 | 2.7% |
| 28 | 260 | 2.6% |
| 36.3 | 252 | 2.5% |
| Other values (278) | 6706 |
| Value | Count | Frequency (%) |
| -275 | 4 | < 0.1% |
| -270 | 14 | |
| -265 | 5 | 0.1% |
| -260 | 10 | |
| -255 | 13 | |
| -250 | 10 | |
| -245 | 1 | < 0.1% |
| -235 | 2 | < 0.1% |
| -230 | 1 | < 0.1% |
| -225 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 50 | 140 | 1.4% |
| 49 | 315 | |
| 48 | 509 | |
| 47 | 353 | |
| 46 | 267 | |
| 45 | 220 | |
| 44 | 77 | 0.8% |
| 43.3 | 1 | < 0.1% |
| 43 | 59 | 0.6% |
| 42 | 69 | 0.7% |
Category
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 681.4 KiB |
| Office Supplies | |
|---|---|
| Furniture | |
| Technology |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 12.802582 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Furniture |
|---|---|
| 2nd row | Furniture |
| 3rd row | Office Supplies |
| 4th row | Furniture |
| 5th row | Office Supplies |
Common Values
| Value | Count | Frequency (%) |
| Office Supplies | 6026 | |
| Furniture | 2121 | 21.2% |
| Technology | 1847 | 18.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| office | 6026 | |
| supplies | 6026 | |
| furniture | 2121 | 13.2% |
| technology | 1847 | 11.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | 8.0% |
| c | 7873 | 6.2% |
| l | 7873 | 6.2% |
| O | 6026 | 4.7% |
| S | 6026 | 4.7% |
| 6026 | 4.7% | |
| Other values (10) | 29560 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 105903 | |
| Uppercase Letter | 16020 | 12.5% |
| Space Separator | 6026 | 4.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | |
| c | 7873 | |
| l | 7873 | |
| s | 6026 | 5.7% |
| r | 4242 | 4.0% |
| n | 3968 | 3.7% |
| Other values (5) | 11356 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 6026 | |
| S | 6026 | |
| F | 2121 | 13.2% |
| T | 1847 | 11.5% |
Space Separator
| Value | Count | Frequency (%) |
| 6026 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 121923 | |
| Common | 6026 | 4.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | |
| c | 7873 | 6.5% |
| l | 7873 | 6.5% |
| O | 6026 | 4.9% |
| S | 6026 | 4.9% |
| s | 6026 | 4.9% |
| Other values (9) | 23534 |
Common
| Value | Count | Frequency (%) |
| 6026 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 127949 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | 8.0% |
| c | 7873 | 6.2% |
| l | 7873 | 6.2% |
| O | 6026 | 4.7% |
| S | 6026 | 4.7% |
| 6026 | 4.7% | |
| Other values (10) | 29560 |
City
Text
| Distinct | 531 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 647.5 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 9.3306984 |
| Min length | 4 |
Unique
| Unique | 70 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | Henderson |
|---|---|
| 2nd row | Henderson |
| 3rd row | Los Angeles |
| 4th row | Fort Lauderdale |
| 5th row | Fort Lauderdale |
| Value | Count | Frequency (%) |
| city | 994 | 7.0% |
| new | 937 | 6.6% |
| york | 920 | 6.5% |
| san | 805 | 5.7% |
| los | 747 | 5.2% |
| angeles | 747 | 5.2% |
| philadelphia | 537 | 3.8% |
| francisco | 510 | 3.6% |
| seattle | 428 | 3.0% |
| houston | 377 | 2.6% |
| Other values (555) | 7234 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 8719 | 9.4% |
| a | 7591 | 8.1% |
| o | 7499 | 8.0% |
| i | 6229 | 6.7% |
| n | 6199 | 6.6% |
| l | 5986 | 6.4% |
| s | 4699 | 5.0% |
| r | 4468 | 4.8% |
| t | 4438 | 4.8% |
| 4242 | 4.5% | |
| Other values (41) | 33181 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 74773 | |
| Uppercase Letter | 14236 | 15.3% |
| Space Separator | 4242 | 4.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 8719 | |
| a | 7591 | |
| o | 7499 | |
| i | 6229 | 8.3% |
| n | 6199 | 8.3% |
| l | 5986 | 8.0% |
| s | 4699 | 6.3% |
| r | 4468 | 6.0% |
| t | 4438 | 5.9% |
| c | 2393 | 3.2% |
| Other values (16) | 16552 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 2085 | |
| S | 1740 | |
| L | 1295 | |
| A | 1242 | |
| N | 1134 | |
| P | 1013 | 7.1% |
| Y | 940 | 6.6% |
| F | 794 | 5.6% |
| D | 627 | 4.4% |
| H | 617 | 4.3% |
| Other values (14) | 2749 |
Space Separator
| Value | Count | Frequency (%) |
| 4242 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 89009 | |
| Common | 4242 | 4.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 8719 | 9.8% |
| a | 7591 | 8.5% |
| o | 7499 | 8.4% |
| i | 6229 | 7.0% |
| n | 6199 | 7.0% |
| l | 5986 | 6.7% |
| s | 4699 | 5.3% |
| r | 4468 | 5.0% |
| t | 4438 | 5.0% |
| c | 2393 | 2.7% |
| Other values (40) | 30788 |
Common
| Value | Count | Frequency (%) |
| 4242 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 93251 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 8719 | 9.4% |
| a | 7591 | 8.1% |
| o | 7499 | 8.0% |
| i | 6229 | 6.7% |
| n | 6199 | 6.6% |
| l | 5986 | 6.4% |
| s | 4699 | 5.0% |
| r | 4468 | 4.8% |
| t | 4438 | 4.8% |
| 4242 | 4.5% | |
| Other values (41) | 33181 |
Country
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 683.3 KiB |
| United States |
|---|
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | United States |
|---|---|
| 2nd row | United States |
| 3rd row | United States |
| 4th row | United States |
| 5th row | United States |
Common Values
| Value | Count | Frequency (%) |
| United States | 9994 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| united | 9994 | |
| states | 9994 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 29982 | |
| e | 19988 | |
| n | 9994 | 7.7% |
| U | 9994 | 7.7% |
| i | 9994 | 7.7% |
| d | 9994 | 7.7% |
| 9994 | 7.7% | |
| S | 9994 | 7.7% |
| a | 9994 | 7.7% |
| s | 9994 | 7.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 99940 | |
| Uppercase Letter | 19988 | 15.4% |
| Space Separator | 9994 | 7.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 29982 | |
| e | 19988 | |
| n | 9994 | 10.0% |
| i | 9994 | 10.0% |
| d | 9994 | 10.0% |
| a | 9994 | 10.0% |
| s | 9994 | 10.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 9994 | |
| S | 9994 |
Space Separator
| Value | Count | Frequency (%) |
| 9994 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 119928 | |
| Common | 9994 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 29982 | |
| e | 19988 | |
| n | 9994 | 8.3% |
| U | 9994 | 8.3% |
| i | 9994 | 8.3% |
| d | 9994 | 8.3% |
| S | 9994 | 8.3% |
| a | 9994 | 8.3% |
| s | 9994 | 8.3% |
Common
| Value | Count | Frequency (%) |
| 9994 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 129922 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 29982 | |
| e | 19988 | |
| n | 9994 | 7.7% |
| U | 9994 | 7.7% |
| i | 9994 | 7.7% |
| d | 9994 | 7.7% |
| 9994 | 7.7% | |
| S | 9994 | 7.7% |
| a | 9994 | 7.7% |
| s | 9994 | 7.7% |
Customer Name
Text
| Distinct | 793 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 686.4 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 18 |
| Mean length | 12.960676 |
| Min length | 7 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Claire Gute |
|---|---|
| 2nd row | Claire Gute |
| 3rd row | Darrin Van Huff |
| 4th row | Sean O'Donnell |
| 5th row | Sean O'Donnell |
| Value | Count | Frequency (%) |
| michael | 120 | 0.6% |
| frank | 112 | 0.6% |
| john | 107 | 0.5% |
| patrick | 96 | 0.5% |
| brian | 93 | 0.5% |
| stewart | 93 | 0.5% |
| paul | 92 | 0.5% |
| rick | 91 | 0.5% |
| ken | 91 | 0.5% |
| matt | 86 | 0.4% |
| Other values (901) | 19072 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 12011 | 9.3% |
| e | 11836 | 9.1% |
| n | 10241 | 7.9% |
| 10059 | 7.8% | |
| r | 9530 | 7.4% |
| i | 7919 | 6.1% |
| l | 6494 | 5.0% |
| o | 5850 | 4.5% |
| t | 5435 | 4.2% |
| s | 4546 | 3.5% |
| Other values (47) | 45608 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 98856 | |
| Uppercase Letter | 20461 | 15.8% |
| Space Separator | 10059 | 7.8% |
| Other Punctuation | 124 | 0.1% |
| Dash Punctuation | 29 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 12011 | |
| e | 11836 | |
| n | 10241 | |
| r | 9530 | |
| i | 7919 | 8.0% |
| l | 6494 | 6.6% |
| o | 5850 | 5.9% |
| t | 5435 | 5.5% |
| s | 4546 | 4.6% |
| h | 3857 | 3.9% |
| Other values (18) | 21137 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 1830 | 8.9% |
| S | 1798 | 8.8% |
| M | 1749 | 8.5% |
| B | 1696 | 8.3% |
| D | 1325 | 6.5% |
| A | 1282 | 6.3% |
| J | 1134 | 5.5% |
| P | 1105 | 5.4% |
| H | 1005 | 4.9% |
| K | 964 | 4.7% |
| Other values (16) | 6573 |
Space Separator
| Value | Count | Frequency (%) |
| 10059 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 124 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 29 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 119317 | |
| Common | 10212 | 7.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 12011 | 10.1% |
| e | 11836 | 9.9% |
| n | 10241 | 8.6% |
| r | 9530 | 8.0% |
| i | 7919 | 6.6% |
| l | 6494 | 5.4% |
| o | 5850 | 4.9% |
| t | 5435 | 4.6% |
| s | 4546 | 3.8% |
| h | 3857 | 3.2% |
| Other values (44) | 41598 |
Common
| Value | Count | Frequency (%) |
| 10059 | ||
| ' | 124 | 1.2% |
| - | 29 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 129440 | |
| None | 89 | 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 12011 | 9.3% |
| e | 11836 | 9.1% |
| n | 10241 | 7.9% |
| 10059 | 7.8% | |
| r | 9530 | 7.4% |
| i | 7919 | 6.1% |
| l | 6494 | 5.0% |
| o | 5850 | 4.5% |
| t | 5435 | 4.2% |
| s | 4546 | 3.5% |
| Other values (44) | 45519 |
None
| Value | Count | Frequency (%) |
| ö | 61 | |
| ä | 23 | 25.8% |
| ü | 5 | 5.6% |
Discount
Real number (ℝ)
High correlation  Zeros 
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.620272 |
| Minimum | 0 |
|---|---|
| Maximum | 80 |
| Zeros | 4798 |
| Zeros (%) | 48.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 20 |
| Q3 | 20 |
| 95-th percentile | 70 |
| Maximum | 80 |
| Range | 80 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 20.645197 |
|---|---|
| Coefficient of variation (CV) | 1.3216925 |
| Kurtosis | 2.4095461 |
| Mean | 15.620272 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | 1.6842947 |
| Sum | 156109 |
| Variance | 426.22415 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4798 | |
| 20 | 3657 | |
| 70 | 418 | 4.2% |
| 80 | 300 | 3.0% |
| 30 | 227 | 2.3% |
| 40 | 206 | 2.1% |
| 60 | 138 | 1.4% |
| 10 | 94 | 0.9% |
| 50 | 66 | 0.7% |
| 15 | 52 | 0.5% |
| Other values (2) | 38 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 4798 | |
| 10 | 94 | 0.9% |
| 15 | 52 | 0.5% |
| 20 | 3657 | |
| 30 | 227 | 2.3% |
| 32 | 27 | 0.3% |
| 40 | 206 | 2.1% |
| 45 | 11 | 0.1% |
| 50 | 66 | 0.7% |
| 60 | 138 | 1.4% |
| Value | Count | Frequency (%) |
| 80 | 300 | 3.0% |
| 70 | 418 | 4.2% |
| 60 | 138 | 1.4% |
| 50 | 66 | 0.7% |
| 45 | 11 | 0.1% |
| 40 | 206 | 2.1% |
| 32 | 27 | 0.3% |
| 30 | 227 | 2.3% |
| 20 | 3657 | |
| 15 | 52 | 0.5% |
Order Date
Date
| Distinct | 1237 |
|---|---|
| Distinct (%) | 12.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| Minimum | 2014-01-03 00:00:00 |
|---|---|
| Maximum | 2017-12-30 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Product Name
Text
| Distinct | 1850 |
|---|---|
| Distinct (%) | 18.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 939.5 KiB |
Length
| Max length | 127 |
|---|---|
| Median length | 78 |
| Mean length | 36.914449 |
| Min length | 5 |
Unique
| Unique | 91 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | Bush Somerset Collection Bookcase |
|---|---|
| 2nd row | Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back |
| 3rd row | Self-Adhesive Address Labels for Typewriters by Universal |
| 4th row | Bretford CR4500 Series Slim Rectangular Table |
| 5th row | Eldon Fold 'N Roll Cart System |
| Value | Count | Frequency (%) |
| xerox | 865 | 1.5% |
| x | 701 | 1.3% |
| with | 599 | 1.1% |
| 599 | 1.1% | |
| avery | 557 | 1.0% |
| for | 539 | 1.0% |
| binders | 524 | 0.9% |
| chair | 479 | 0.9% |
| black | 426 | 0.8% |
| phone | 374 | 0.7% |
| Other values (2798) | 50371 |
Most occurring characters
| Value | Count | Frequency (%) |
| 45654 | 12.4% | |
| e | 33538 | 9.1% |
| r | 20791 | 5.6% |
| o | 19902 | 5.4% |
| a | 19064 | 5.2% |
| i | 18648 | 5.1% |
| l | 16365 | 4.4% |
| n | 15622 | 4.2% |
| s | 14683 | 4.0% |
| t | 14550 | 3.9% |
| Other values (75) | 150106 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 238253 | |
| Uppercase Letter | 56270 | 15.3% |
| Space Separator | 46081 | 12.5% |
| Decimal Number | 17981 | 4.9% |
| Other Punctuation | 7152 | 1.9% |
| Dash Punctuation | 2940 | 0.8% |
| Final Punctuation | 67 | < 0.1% |
| Close Punctuation | 60 | < 0.1% |
| Open Punctuation | 60 | < 0.1% |
| Math Symbol | 35 | < 0.1% |
| Other values (2) | 24 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 33538 | |
| r | 20791 | 8.7% |
| o | 19902 | 8.4% |
| a | 19064 | 8.0% |
| i | 18648 | 7.8% |
| l | 16365 | 6.9% |
| n | 15622 | 6.6% |
| s | 14683 | 6.2% |
| t | 14550 | 6.1% |
| c | 8924 | 3.7% |
| Other values (18) | 56166 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 6281 | 11.2% |
| C | 6007 | 10.7% |
| B | 5530 | 9.8% |
| P | 4918 | 8.7% |
| A | 2948 | 5.2% |
| D | 2941 | 5.2% |
| M | 2870 | 5.1% |
| T | 2616 | 4.6% |
| F | 2510 | 4.5% |
| L | 2284 | 4.1% |
| Other values (16) | 17365 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 3120 | |
| / | 1561 | |
| " | 1300 | |
| . | 463 | 6.5% |
| & | 287 | 4.0% |
| ' | 257 | 3.6% |
| # | 90 | 1.3% |
| % | 45 | 0.6% |
| ! | 9 | 0.1% |
| * | 9 | 0.1% |
| Other values (2) | 11 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 3783 | |
| 0 | 2921 | |
| 2 | 2270 | |
| 4 | 1725 | |
| 3 | 1530 | |
| 5 | 1443 | 8.0% |
| 8 | 1254 | 7.0% |
| 9 | 1234 | 6.9% |
| 6 | 941 | 5.2% |
| 7 | 880 | 4.9% |
Space Separator
| Value | Count | Frequency (%) |
| 45654 | ||
| 427 | 0.9% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2940 |
Final Punctuation
| Value | Count | Frequency (%) |
| ” | 67 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 60 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 60 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 35 |
Initial Punctuation
| Value | Count | Frequency (%) |
| “ | 19 |
Other Number
| Value | Count | Frequency (%) |
| ¾ | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 294523 | |
| Common | 74400 | 20.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 33538 | 11.4% |
| r | 20791 | 7.1% |
| o | 19902 | 6.8% |
| a | 19064 | 6.5% |
| i | 18648 | 6.3% |
| l | 16365 | 5.6% |
| n | 15622 | 5.3% |
| s | 14683 | 5.0% |
| t | 14550 | 4.9% |
| c | 8924 | 3.0% |
| Other values (44) | 112436 |
Common
| Value | Count | Frequency (%) |
| 45654 | ||
| 1 | 3783 | 5.1% |
| , | 3120 | 4.2% |
| - | 2940 | 4.0% |
| 0 | 2921 | 3.9% |
| 2 | 2270 | 3.1% |
| 4 | 1725 | 2.3% |
| / | 1561 | 2.1% |
| 3 | 1530 | 2.1% |
| 5 | 1443 | 1.9% |
| Other values (21) | 7453 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 368388 | |
| None | 449 | 0.1% |
| Punctuation | 86 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 45654 | 12.4% | |
| e | 33538 | 9.1% |
| r | 20791 | 5.6% |
| o | 19902 | 5.4% |
| a | 19064 | 5.2% |
| i | 18648 | 5.1% |
| l | 16365 | 4.4% |
| n | 15622 | 4.2% |
| s | 14683 | 4.0% |
| t | 14550 | 3.9% |
| Other values (69) | 149571 |
None
| Value | Count | Frequency (%) |
| 427 | ||
| é | 14 | 3.1% |
| ¾ | 5 | 1.1% |
| à | 3 | 0.7% |
Punctuation
| Value | Count | Frequency (%) |
| ” | 67 | |
| “ | 19 | 22.1% |
Quantity
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7895737 |
| Minimum | 1 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.2251097 |
|---|---|
| Coefficient of variation (CV) | 0.58716622 |
| Kurtosis | 1.9918894 |
| Mean | 3.7895737 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.2785448 |
| Sum | 37873 |
| Variance | 4.9511131 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 2409 | |
| 2 | 2402 | |
| 5 | 1230 | |
| 4 | 1191 | |
| 1 | 899 | 9.0% |
| 7 | 606 | 6.1% |
| 6 | 572 | 5.7% |
| 9 | 258 | 2.6% |
| 8 | 257 | 2.6% |
| 10 | 57 | 0.6% |
| Other values (4) | 113 | 1.1% |
| Value | Count | Frequency (%) |
| 1 | 899 | 9.0% |
| 2 | 2402 | |
| 3 | 2409 | |
| 4 | 1191 | |
| 5 | 1230 | |
| 6 | 572 | 5.7% |
| 7 | 606 | 6.1% |
| 8 | 257 | 2.6% |
| 9 | 258 | 2.6% |
| 10 | 57 | 0.6% |
| Value | Count | Frequency (%) |
| 14 | 29 | 0.3% |
| 13 | 27 | 0.3% |
| 12 | 23 | 0.2% |
| 11 | 34 | 0.3% |
| 10 | 57 | 0.6% |
| 9 | 258 | 2.6% |
| 8 | 257 | 2.6% |
| 7 | 606 | |
| 6 | 572 | |
| 5 | 1230 |
Region
Categorical
High correlation 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 603.9 KiB |
| West | |
|---|---|
| East | |
| Central | |
| South |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.8594156 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | South |
|---|---|
| 2nd row | South |
| 3rd row | West |
| 4th row | South |
| 5th row | South |
Common Values
| Value | Count | Frequency (%) |
| West | 3203 | |
| East | 2848 | |
| Central | 2323 | |
| South | 1620 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| west | 3203 | |
| east | 2848 | |
| central | 2323 | |
| south | 1620 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| W | 3203 | 6.6% |
| E | 2848 | 5.9% |
| C | 2323 | 4.8% |
| n | 2323 | 4.8% |
| r | 2323 | 4.8% |
| l | 2323 | 4.8% |
| Other values (4) | 6480 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 38571 | |
| Uppercase Letter | 9994 | 20.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| n | 2323 | 6.0% |
| r | 2323 | 6.0% |
| l | 2323 | 6.0% |
| o | 1620 | 4.2% |
| u | 1620 | 4.2% |
| h | 1620 | 4.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 3203 | |
| E | 2848 | |
| C | 2323 | |
| S | 1620 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 48565 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| W | 3203 | 6.6% |
| E | 2848 | 5.9% |
| C | 2323 | 4.8% |
| n | 2323 | 4.8% |
| r | 2323 | 4.8% |
| l | 2323 | 4.8% |
| Other values (4) | 6480 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 48565 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| W | 3203 | 6.6% |
| E | 2848 | 5.9% |
| C | 2323 | 4.8% |
| n | 2323 | 4.8% |
| r | 2323 | 4.8% |
| l | 2323 | 4.8% |
| Other values (4) | 6480 |
Profit per Order
Real number (ℝ)
High correlation 
| Distinct | 5157 |
|---|---|
| Distinct (%) | 51.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.656785 |
| Minimum | -6599.98 |
|---|---|
| Maximum | 8399.98 |
| Zeros | 65 |
| Zeros (%) | 0.7% |
| Negative | 1871 |
| Negative (%) | 18.7% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | -6599.98 |
|---|---|
| 5-th percentile | -53.031 |
| Q1 | 1.73 |
| median | 8.665 |
| Q3 | 29.36 |
| 95-th percentile | 168.47 |
| Maximum | 8399.98 |
| Range | 14999.96 |
| Interquartile range (IQR) | 27.63 |
Descriptive statistics
| Standard deviation | 234.26014 |
|---|---|
| Coefficient of variation (CV) | 8.1746834 |
| Kurtosis | 397.18871 |
| Mean | 28.656785 |
| Median Absolute Deviation (MAD) | 10.78 |
| Skewness | 7.5614403 |
| Sum | 286395.91 |
| Variance | 54877.815 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 65 | 0.7% |
| 6.22 | 50 | 0.5% |
| 9.33 | 39 | 0.4% |
| 3.63 | 35 | 0.4% |
| 5.44 | 33 | 0.3% |
| 15.55 | 26 | 0.3% |
| 7.26 | 21 | 0.2% |
| 12.44 | 21 | 0.2% |
| 3.11 | 20 | 0.2% |
| 6.87 | 16 | 0.2% |
| Other values (5147) | 9668 |
| Value | Count | Frequency (%) |
| -6599.98 | 1 | |
| -3839.99 | 1 | |
| -3701.89 | 1 | |
| -3399.98 | 1 | |
| -2929.48 | 1 | |
| -2639.99 | 1 | |
| -2287.78 | 1 | |
| -1862.31 | 1 | |
| -1850.95 | 1 | |
| -1811.08 | 1 |
| Value | Count | Frequency (%) |
| 8399.98 | 1 | |
| 6719.98 | 1 | |
| 5039.99 | 1 | |
| 4946.37 | 1 | |
| 4630.48 | 1 | |
| 3919.99 | 1 | |
| 3177.47 | 1 | |
| 2799.98 | 1 | |
| 2591.96 | 1 | |
| 2504.22 | 1 |
Segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 642.7 KiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.8374024 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumer |
|---|---|
| 2nd row | Consumer |
| 3rd row | Corporate |
| 4th row | Consumer |
| 5th row | Consumer |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 5191 | |
| Corporate | 3020 | |
| Home Office | 1783 | 17.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 5191 | |
| corporate | 3020 | |
| home | 1783 | 15.1% |
| office | 1783 | 15.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| C | 8211 | |
| m | 6974 | |
| u | 5191 | 5.9% |
| s | 5191 | 5.9% |
| n | 5191 | 5.9% |
| f | 3566 | 4.0% |
| p | 3020 | 3.4% |
| Other values (7) | 14955 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 74761 | |
| Uppercase Letter | 11777 | 13.3% |
| Space Separator | 1783 | 2.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| m | 6974 | |
| u | 5191 | 6.9% |
| s | 5191 | 6.9% |
| n | 5191 | 6.9% |
| f | 3566 | 4.8% |
| p | 3020 | 4.0% |
| a | 3020 | 4.0% |
| Other values (3) | 6586 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 8211 | |
| H | 1783 | 15.1% |
| O | 1783 | 15.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1783 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 86538 | |
| Common | 1783 | 2.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| C | 8211 | |
| m | 6974 | |
| u | 5191 | 6.0% |
| s | 5191 | 6.0% |
| n | 5191 | 6.0% |
| f | 3566 | 4.1% |
| p | 3020 | 3.5% |
| Other values (6) | 13172 |
Common
| Value | Count | Frequency (%) |
| 1783 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 88321 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| C | 8211 | |
| m | 6974 | |
| u | 5191 | 5.9% |
| s | 5191 | 5.9% |
| n | 5191 | 5.9% |
| f | 3566 | 4.0% |
| p | 3020 | 3.4% |
| Other values (7) | 14955 |
Ship Mode
Categorical
High correlation  Missing 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 543 |
| Missing (%) | 5.4% |
| Memory size | 587.8 KiB |
| 0.0 | |
|---|---|
| 1.0 | |
| 2.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 5968 | |
| 1.0 | 1945 | 19.5% |
| 2.0 | 1538 | 15.4% |
| (Missing) | 543 | 5.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 5968 | |
| 1.0 | 1945 | 20.6% |
| 2.0 | 1538 | 16.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 15419 | |
| . | 9451 | |
| 1 | 1945 | 6.9% |
| 2 | 1538 | 5.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 18902 | |
| Other Punctuation | 9451 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 15419 | |
| 1 | 1945 | 10.3% |
| 2 | 1538 | 8.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 9451 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 28353 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 15419 | |
| . | 9451 | |
| 1 | 1945 | 6.9% |
| 2 | 1538 | 5.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 28353 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 15419 | |
| . | 9451 | |
| 1 | 1945 | 6.9% |
| 2 | 1538 | 5.4% |
State
Categorical
High correlation 
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 639.3 KiB |
| California | |
|---|---|
| New York | |
| Texas | |
| Pennsylvania | |
| Washington | |
| Other values (44) |
Length
| Max length | 20 |
|---|---|
| Median length | 14 |
| Mean length | 8.4871923 |
| Min length | 4 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Kentucky |
|---|---|
| 2nd row | Kentucky |
| 3rd row | California |
| 4th row | Florida |
| 5th row | Florida |
Common Values
| Value | Count | Frequency (%) |
| California | 2001 | |
| New York | 1128 | 11.3% |
| Texas | 985 | 9.9% |
| Pennsylvania | 587 | 5.9% |
| Washington | 506 | 5.1% |
| Illinois | 492 | 4.9% |
| Ohio | 469 | 4.7% |
| Florida | 383 | 3.8% |
| Michigan | 255 | 2.6% |
| North Carolina | 249 | 2.5% |
| Other values (39) | 2939 |
Length
| Value | Count | Frequency (%) |
| california | 2001 | |
| new | 1322 | 11.3% |
| york | 1128 | 9.6% |
| texas | 985 | 8.4% |
| pennsylvania | 587 | 5.0% |
| washington | 506 | 4.3% |
| illinois | 492 | 4.2% |
| ohio | 469 | 4.0% |
| florida | 383 | 3.3% |
| carolina | 291 | 2.5% |
| Other values (43) | 3542 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 10758 | |
| i | 9895 | |
| n | 8090 | 9.5% |
| o | 7323 | 8.6% |
| r | 5544 | 6.5% |
| e | 5051 | 6.0% |
| l | 4822 | 5.7% |
| s | 4604 | 5.4% |
| C | 2566 | 3.0% |
| f | 2011 | 2.4% |
| Other values (36) | 24157 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 71413 | |
| Uppercase Letter | 11696 | 13.8% |
| Space Separator | 1712 | 2.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 10758 | |
| i | 9895 | |
| n | 8090 | |
| o | 7323 | |
| r | 5544 | |
| e | 5051 | |
| l | 4822 | |
| s | 4604 | |
| f | 2011 | 2.8% |
| h | 1898 | 2.7% |
| Other values (14) | 11417 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 2566 | |
| N | 1655 | |
| T | 1168 | |
| Y | 1128 | |
| M | 763 | 6.5% |
| I | 748 | 6.4% |
| O | 659 | 5.6% |
| W | 621 | 5.3% |
| P | 587 | 5.0% |
| F | 383 | 3.3% |
| Other values (11) | 1418 |
Space Separator
| Value | Count | Frequency (%) |
| 1712 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 83109 | |
| Common | 1712 | 2.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 10758 | |
| i | 9895 | |
| n | 8090 | 9.7% |
| o | 7323 | 8.8% |
| r | 5544 | 6.7% |
| e | 5051 | 6.1% |
| l | 4822 | 5.8% |
| s | 4604 | 5.5% |
| C | 2566 | 3.1% |
| f | 2011 | 2.4% |
| Other values (35) | 22445 |
Common
| Value | Count | Frequency (%) |
| 1712 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 84821 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 10758 | |
| i | 9895 | |
| n | 8090 | 9.5% |
| o | 7323 | 8.6% |
| r | 5544 | 6.5% |
| e | 5051 | 6.0% |
| l | 4822 | 5.7% |
| s | 4604 | 5.4% |
| C | 2566 | 3.0% |
| f | 2011 | 2.4% |
| Other values (36) | 24157 |
Sub-Category
Categorical
High correlation 
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 626.6 KiB |
| Binders | |
|---|---|
| Paper | |
| Furnishings | |
| Phones | |
| Storage | |
| Other values (12) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 7.191715 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bookcases |
|---|---|
| 2nd row | Chairs |
| 3rd row | Labels |
| 4th row | Tables |
| 5th row | Storage |
Common Values
| Value | Count | Frequency (%) |
| Binders | 1523 | |
| Paper | 1370 | |
| Furnishings | 957 | |
| Phones | 889 | |
| Storage | 846 | |
| Art | 796 | |
| Accessories | 775 | |
| Chairs | 617 | |
| Appliances | 466 | 4.7% |
| Labels | 364 | 3.6% |
| Other values (7) | 1391 |
Length
| Value | Count | Frequency (%) |
| binders | 1523 | |
| paper | 1370 | |
| furnishings | 957 | |
| phones | 889 | |
| storage | 846 | |
| art | 796 | |
| accessories | 775 | |
| chairs | 617 | |
| appliances | 466 | 4.7% |
| labels | 364 | 3.6% |
| Other values (7) | 1391 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | 10.0% |
| i | 5668 | 7.9% |
| n | 5378 | 7.5% |
| a | 4542 | 6.3% |
| o | 3288 | 4.6% |
| p | 3004 | 4.2% |
| h | 2578 | 3.6% |
| c | 2359 | 3.3% |
| Other values (18) | 19084 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 61880 | |
| Uppercase Letter | 9994 | 13.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | |
| i | 5668 | |
| n | 5378 | |
| a | 4542 | |
| o | 3288 | 5.3% |
| p | 3004 | 4.9% |
| h | 2578 | 4.2% |
| c | 2359 | 3.8% |
| Other values (8) | 9090 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 2259 | |
| A | 2037 | |
| B | 1751 | |
| F | 1174 | |
| S | 1036 | |
| C | 685 | 6.9% |
| L | 364 | 3.6% |
| T | 319 | 3.2% |
| E | 254 | 2.5% |
| M | 115 | 1.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 71874 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | 10.0% |
| i | 5668 | 7.9% |
| n | 5378 | 7.5% |
| a | 4542 | 6.3% |
| o | 3288 | 4.6% |
| p | 3004 | 4.2% |
| h | 2578 | 3.6% |
| c | 2359 | 3.3% |
| Other values (18) | 19084 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 71874 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | 10.0% |
| i | 5668 | 7.9% |
| n | 5378 | 7.5% |
| a | 4542 | 6.3% |
| o | 3288 | 4.6% |
| p | 3004 | 4.2% |
| h | 2578 | 3.6% |
| c | 2359 | 3.3% |
| Other values (18) | 19084 |
Year
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 595.5 KiB |
| 2017 | |
|---|---|
| 2016 | |
| 2015 | |
| 2014 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2016 |
|---|---|
| 2nd row | 2016 |
| 3rd row | 2016 |
| 4th row | 2015 |
| 5th row | 2015 |
Common Values
| Value | Count | Frequency (%) |
| 2017 | 3312 | |
| 2016 | 2587 | |
| 2015 | 2102 | |
| 2014 | 1993 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2017 | 3312 | |
| 2016 | 2587 | |
| 2015 | 2102 | |
| 2014 | 1993 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 9994 | |
| 0 | 9994 | |
| 1 | 9994 | |
| 7 | 3312 | 8.3% |
| 6 | 2587 | 6.5% |
| 5 | 2102 | 5.3% |
| 4 | 1993 | 5.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 39976 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 9994 | |
| 0 | 9994 | |
| 1 | 9994 | |
| 7 | 3312 | 8.3% |
| 6 | 2587 | 6.5% |
| 5 | 2102 | 5.3% |
| 4 | 1993 | 5.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 39976 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 9994 | |
| 0 | 9994 | |
| 1 | 9994 | |
| 7 | 3312 | 8.3% |
| 6 | 2587 | 6.5% |
| 5 | 2102 | 5.3% |
| 4 | 1993 | 5.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 39976 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 9994 | |
| 0 | 9994 | |
| 1 | 9994 | |
| 7 | 3312 | 8.3% |
| 6 | 2587 | 6.5% |
| 5 | 2102 | 5.3% |
| 4 | 1993 | 5.0% |
Month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.8096858 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 9 |
| Q3 | 11 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.2846544 |
|---|---|
| Coefficient of variation (CV) | 0.42058727 |
| Kurtosis | -0.99132786 |
| Mean | 7.8096858 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.42969297 |
| Sum | 78050 |
| Variance | 10.788955 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11 | 1471 | |
| 12 | 1408 | |
| 9 | 1383 | |
| 10 | 819 | |
| 5 | 735 | |
| 6 | 717 | |
| 7 | 710 | |
| 8 | 706 | |
| 3 | 696 | |
| 4 | 668 | |
| Other values (2) | 681 |
| Value | Count | Frequency (%) |
| 1 | 381 | 3.8% |
| 2 | 300 | 3.0% |
| 3 | 696 | |
| 4 | 668 | |
| 5 | 735 | |
| 6 | 717 | |
| 7 | 710 | |
| 8 | 706 | |
| 9 | 1383 | |
| 10 | 819 |
| Value | Count | Frequency (%) |
| 12 | 1408 | |
| 11 | 1471 | |
| 10 | 819 | |
| 9 | 1383 | |
| 8 | 706 | |
| 7 | 710 | |
| 6 | 717 | |
| 5 | 735 | |
| 4 | 668 | |
| 3 | 696 |
Interactions
Correlations
| Category | Days to Ship Actual | Days to Ship Scheduled | Discount | Month | Profit Ratio | Profit per Order | Quantity | Region | Sales per Customer | Segment | Ship Mode | Ship Status | State | Sub-Category | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Category | 1.000 | 0.000 | 0.000 | 0.377 | 0.014 | 0.271 | 0.056 | 0.000 | 0.000 | 0.072 | 0.000 | 0.000 | 0.000 | 0.019 | 0.999 | 0.000 |
| Days to Ship Actual | 0.000 | 1.000 | 0.781 | -0.014 | 0.004 | 0.004 | -0.007 | 0.016 | 0.041 | -0.015 | 0.043 | 0.666 | 0.780 | 0.102 | 0.001 | 0.047 |
| Days to Ship Scheduled | 0.000 | 0.781 | 1.000 | 0.027 | 0.044 | 0.012 | 0.005 | 0.000 | 0.022 | 0.000 | 0.033 | 1.000 | 0.506 | 0.096 | 0.007 | 0.023 |
| Discount | 0.377 | -0.014 | 0.027 | 1.000 | -0.001 | -0.645 | -0.543 | -0.001 | 0.294 | -0.057 | 0.005 | 0.037 | 0.021 | 0.354 | 0.353 | 0.000 |
| Month | 0.014 | 0.004 | 0.044 | -0.001 | 1.000 | 0.002 | 0.017 | 0.022 | 0.040 | 0.015 | 0.042 | 0.031 | 0.052 | 0.098 | 0.000 | 0.026 |
| Profit Ratio | 0.271 | 0.004 | 0.012 | -0.645 | 0.002 | 1.000 | 0.500 | 0.000 | 0.203 | -0.201 | 0.017 | 0.020 | 0.019 | 0.228 | 0.304 | 0.000 |
| Profit per Order | 0.056 | -0.007 | 0.005 | -0.543 | 0.017 | 0.500 | 1.000 | 0.234 | 0.021 | 0.518 | 0.000 | 0.000 | 0.012 | 0.017 | 0.130 | 0.000 |
| Quantity | 0.000 | 0.016 | 0.000 | -0.001 | 0.022 | 0.000 | 0.234 | 1.000 | 0.000 | 0.327 | 0.012 | 0.000 | 0.009 | 0.004 | 0.000 | 0.013 |
| Region | 0.000 | 0.041 | 0.022 | 0.294 | 0.040 | 0.203 | 0.021 | 0.000 | 1.000 | 0.000 | 0.000 | 0.030 | 0.007 | 0.998 | 0.000 | 0.016 |
| Sales per Customer | 0.072 | -0.015 | 0.000 | -0.057 | 0.015 | -0.201 | 0.518 | 0.327 | 0.000 | 1.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.142 | 0.000 |
| Segment | 0.000 | 0.043 | 0.033 | 0.005 | 0.042 | 0.017 | 0.000 | 0.012 | 0.000 | 0.002 | 1.000 | 0.007 | 0.027 | 0.090 | 0.000 | 0.028 |
| Ship Mode | 0.000 | 0.666 | 1.000 | 0.037 | 0.031 | 0.020 | 0.000 | 0.000 | 0.030 | 0.000 | 0.007 | 1.000 | 0.422 | 0.104 | 0.017 | 0.026 |
| Ship Status | 0.000 | 0.780 | 0.506 | 0.021 | 0.052 | 0.019 | 0.012 | 0.009 | 0.007 | 0.000 | 0.027 | 0.422 | 1.000 | 0.092 | 0.000 | 0.048 |
| State | 0.019 | 0.102 | 0.096 | 0.354 | 0.098 | 0.228 | 0.017 | 0.004 | 0.998 | 0.000 | 0.090 | 0.104 | 0.092 | 1.000 | 0.000 | 0.089 |
| Sub-Category | 0.999 | 0.001 | 0.007 | 0.353 | 0.000 | 0.304 | 0.130 | 0.000 | 0.000 | 0.142 | 0.000 | 0.017 | 0.000 | 0.000 | 1.000 | 0.000 |
| Year | 0.000 | 0.047 | 0.023 | 0.000 | 0.026 | 0.000 | 0.000 | 0.013 | 0.016 | 0.000 | 0.028 | 0.026 | 0.048 | 0.089 | 0.000 | 1.000 |
Missing values
Sample
| Days to Ship Actual | Ship Status | Days to Ship Scheduled | Sales per Customer | Profit Ratio | Category | City | Country | Customer Name | Discount | Order Date | Product Name | Quantity | Region | Profit per Order | Segment | Ship Mode | State | Sub-Category | Year | Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 3 | 1 | 3 | 261.96 | 16.0 | Furniture | Henderson | United States | Claire Gute | 0.0 | 2016-11-08 | Bush Somerset Collection Bookcase | 2 | South | 41.91 | Consumer | 1.0 | Kentucky | Bookcases | 2016 | 11 |
| 1 | 3 | 1 | 3 | 731.94 | 30.0 | Furniture | Henderson | United States | Claire Gute | 0.0 | 2016-11-08 | Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back | 3 | South | 219.58 | Consumer | 1.0 | Kentucky | Chairs | 2016 | 11 |
| 2 | 4 | -1 | 3 | 14.62 | 47.0 | Office Supplies | Los Angeles | United States | Darrin Van Huff | 0.0 | 2016-06-12 | Self-Adhesive Address Labels for Typewriters by Universal | 2 | West | 6.87 | Corporate | 1.0 | California | Labels | 2016 | 6 |
| 3 | 7 | -1 | 6 | 957.58 | -40.0 | Furniture | Fort Lauderdale | United States | Sean O'Donnell | 45.0 | 2015-10-11 | Bretford CR4500 Series Slim Rectangular Table | 5 | South | -383.03 | Consumer | 0.0 | Florida | Tables | 2015 | 10 |
| 4 | 7 | -1 | 6 | 22.37 | 11.3 | Office Supplies | Fort Lauderdale | United States | Sean O'Donnell | 20.0 | 2015-10-11 | Eldon Fold 'N Roll Cart System | 2 | South | 2.52 | Consumer | 0.0 | Florida | Storage | 2015 | 10 |
| 5 | 5 | 2 | 6 | 48.86 | 29.0 | Furniture | Los Angeles | United States | Brosina Hoffman | 0.0 | 2014-06-09 | Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood | 7 | West | 14.17 | Consumer | 0.0 | California | Furnishings | 2014 | 6 |
| 6 | 5 | 2 | 6 | 7.28 | 27.0 | Office Supplies | Los Angeles | United States | Brosina Hoffman | 0.0 | 2014-06-09 | Newell 322 | 4 | West | 1.97 | Consumer | 0.0 | California | Art | 2014 | 6 |
| 7 | 5 | 2 | 6 | 907.15 | 10.0 | Technology | Los Angeles | United States | Brosina Hoffman | 20.0 | 2014-06-09 | Mitel 5320 IP Phone VoIP phone | 6 | West | 90.72 | Consumer | 0.0 | California | Phones | 2014 | 6 |
| 8 | 5 | 2 | 6 | 18.50 | 31.3 | Office Supplies | Los Angeles | United States | Brosina Hoffman | 20.0 | 2014-06-09 | DXL Angle-View Binders with Locking Rings by Samsill | 3 | West | 5.78 | Consumer | 0.0 | California | Binders | 2014 | 6 |
| 9 | 5 | 2 | 6 | 114.90 | 30.0 | Office Supplies | Los Angeles | United States | Brosina Hoffman | 0.0 | 2014-06-09 | Belkin F5C206VTEL 6 Outlet Surge | 5 | West | 34.47 | Consumer | 0.0 | California | Appliances | 2014 | 6 |
| Days to Ship Actual | Ship Status | Days to Ship Scheduled | Sales per Customer | Profit Ratio | Category | City | Country | Customer Name | Discount | Order Date | Product Name | Quantity | Region | Profit per Order | Segment | Ship Mode | State | Sub-Category | Year | Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9984 | 6 | 1 | 6 | 31.50 | 48.0 | Office Supplies | Long Beach | United States | Dianna Vittorini | 0.0 | 2015-05-17 | Self-Adhesive Removable Labels | 10 | East | 15.12 | Consumer | 0.0 | New York | Labels | 2015 | 5 |
| 9985 | 6 | 1 | 6 | 55.60 | 29.0 | Office Supplies | Long Beach | United States | Dianna Vittorini | 0.0 | 2015-05-17 | Acme Hot Forged Carbon Steel Scissors with Nickel-Plated Handles, 3 7/8" Cut, 8"L | 4 | East | 16.12 | Consumer | 0.0 | New York | Supplies | 2015 | 5 |
| 9986 | 4 | 2 | 6 | 36.24 | 42.0 | Technology | Los Angeles | United States | Maris LaWare | 0.0 | 2016-09-29 | Memorex Mini Travel Drive 64 GB USB 2.0 Flash Drive | 1 | West | 15.22 | Consumer | 0.0 | California | Accessories | 2016 | 9 |
| 9987 | 4 | 2 | 6 | 79.99 | 36.0 | Technology | Athens | United States | Ruben Ausman | 0.0 | 2017-11-17 | Logitech G430 Surround Sound Gaming Headset with Dolby 7.1 Technology | 1 | South | 28.80 | Corporate | 0.0 | Georgia | Accessories | 2017 | 11 |
| 9988 | 4 | 2 | 6 | 206.10 | 27.0 | Technology | Athens | United States | Ruben Ausman | 0.0 | 2017-11-17 | Panasonic KX - TS880B Telephone | 5 | South | 55.65 | Corporate | 0.0 | Georgia | Phones | 2017 | 11 |
| 9989 | 2 | 2 | 3 | 25.25 | 16.3 | Furniture | Miami | United States | Tom Boeckenhauer | 20.0 | 2014-01-21 | Ultra Door Pull Handle | 3 | South | 4.10 | Consumer | 1.0 | Florida | Furnishings | 2014 | 1 |
| 9990 | 5 | 2 | 6 | 91.96 | 17.0 | Furniture | Costa Mesa | United States | Dave Brooks | 0.0 | 2017-02-26 | Tenex B1-RE Series Chair Mats for Low Pile Carpets | 2 | West | 15.63 | Consumer | 0.0 | California | Furnishings | 2017 | 2 |
| 9991 | 5 | 2 | 6 | 258.58 | 7.5 | Technology | Costa Mesa | United States | Dave Brooks | 20.0 | 2017-02-26 | Aastra 57i VoIP phone | 2 | West | 19.39 | Consumer | 0.0 | California | Phones | 2017 | 2 |
| 9992 | 5 | 2 | 6 | 29.60 | 45.0 | Office Supplies | Costa Mesa | United States | Dave Brooks | 0.0 | 2017-02-26 | It's Hot Message Books with Stickers, 2 3/4" x 5" | 4 | West | 13.32 | Consumer | 0.0 | California | Paper | 2017 | 2 |
| 9993 | 5 | -1 | 3 | 243.16 | 30.0 | Office Supplies | Westminster | United States | Chris Cortes | 0.0 | 2017-05-04 | Acco 7-Outlet Masterpiece Power Center, Wihtout Fax/Phone Line Protection | 2 | West | 72.95 | Consumer | 1.0 | California | Appliances | 2017 | 5 |
Duplicate rows
Most frequently occurring
| Days to Ship Actual | Ship Status | Days to Ship Scheduled | Sales per Customer | Profit Ratio | Category | City | Country | Customer Name | Discount | Order Date | Product Name | Quantity | Region | Profit per Order | Segment | Ship Mode | State | Sub-Category | Year | Month | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 4 | 2 | 6 | 281.37 | -4.3 | Furniture | Columbus | United States | Laurel Beltran | 30.0 | 2014-04-23 | Global Leather Highback Executive Chair with Pneumatic Height Adjustment, Black | 2 | East | -12.06 | Home Office | 0.0 | Ohio | Chairs | 2014 | 4 | 2 |